package com.hailong.zyt.mapper;

/*
* 多表查询
* */

import com.hailong.zyt.beans.Student;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface MultiTableMapper {

    @Select("select * from student s " +
            "where s.stu_id not in (select hw_id from homework_student hws where hws.hw_id = #{hwId})")
    List<Student> getStudentsNotFinish(@Param("hwId") Long hwId);
}
